Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	950
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	89.2 KiB
Average record size in memory	96.1 B

Variable types

Numeric	12

Alerts

`amperestunden` is highly correlated with `zyklus_` and 5 other fields	High correlation
`zyklus_` is highly correlated with `amperestunden` and 4 other fields	High correlation
`temperature_amax` is highly correlated with `temperature_amin` and 3 other fields	High correlation
`temperature_amin` is highly correlated with `temperature_amax` and 3 other fields	High correlation
`temperature_mean` is highly correlated with `temperature_amax` and 3 other fields	High correlation
`time_amin` is highly correlated with `amperestunden` and 6 other fields	High correlation
`time_entladen_stark_vorher` is highly correlated with `amperestunden` and 6 other fields	High correlation
`time_entladen_leicht_vorher` is highly correlated with `amperestunden` and 3 other fields	High correlation
`time_laden_stark_vorher` is highly correlated with `amperestunden` and 4 other fields	High correlation
`time_pause_vorher` is highly correlated with `amperestunden` and 5 other fields	High correlation
`time_temp_hoch` is highly correlated with `temperature_amax` and 3 other fields	High correlation
`time_temp_hoch_vorher` is highly correlated with `temperature_amax` and 7 other fields	High correlation
`amperestunden` is highly correlated with `zyklus_` and 4 other fields	High correlation
`zyklus_` is highly correlated with `amperestunden` and 2 other fields	High correlation
`temperature_amax` is highly correlated with `temperature_amin` and 1 other fields	High correlation
`temperature_amin` is highly correlated with `temperature_amax` and 1 other fields	High correlation
`temperature_mean` is highly correlated with `temperature_amax` and 1 other fields	High correlation
`time_amin` is highly correlated with `amperestunden` and 5 other fields	High correlation
`time_entladen_stark_vorher` is highly correlated with `amperestunden` and 3 other fields	High correlation
`time_entladen_leicht_vorher` is highly correlated with `amperestunden` and 2 other fields	High correlation
`time_laden_stark_vorher` is highly correlated with `amperestunden` and 3 other fields	High correlation
`time_pause_vorher` is highly correlated with `time_amin` and 2 other fields	High correlation
`time_temp_hoch` is highly correlated with `time_temp_hoch_vorher`	High correlation
`time_temp_hoch_vorher` is highly correlated with `time_temp_hoch`	High correlation
`amperestunden` is highly correlated with `zyklus_` and 4 other fields	High correlation
`zyklus_` is highly correlated with `amperestunden` and 3 other fields	High correlation
`temperature_amax` is highly correlated with `temperature_amin` and 2 other fields	High correlation
`temperature_amin` is highly correlated with `temperature_amax` and 2 other fields	High correlation
`temperature_mean` is highly correlated with `temperature_amax` and 2 other fields	High correlation
`time_amin` is highly correlated with `amperestunden` and 4 other fields	High correlation
`time_entladen_stark_vorher` is highly correlated with `amperestunden` and 4 other fields	High correlation
`time_entladen_leicht_vorher` is highly correlated with `amperestunden` and 2 other fields	High correlation
`time_laden_stark_vorher` is highly correlated with `amperestunden` and 3 other fields	High correlation
`time_pause_vorher` is highly correlated with `time_amin` and 1 other fields	High correlation
`time_temp_hoch` is highly correlated with `temperature_amax` and 2 other fields	High correlation
`amperestunden` is highly correlated with `zyklus_` and 6 other fields	High correlation
`zyklus_` is highly correlated with `amperestunden` and 7 other fields	High correlation
`temperature_amax` is highly correlated with `temperature_amin` and 1 other fields	High correlation
`temperature_amin` is highly correlated with `temperature_amax` and 2 other fields	High correlation
`temperature_mean` is highly correlated with `temperature_amax` and 1 other fields	High correlation
`time_amin` is highly correlated with `amperestunden` and 7 other fields	High correlation
`time_entladen_stark_vorher` is highly correlated with `amperestunden` and 7 other fields	High correlation
`time_entladen_leicht_vorher` is highly correlated with `amperestunden` and 7 other fields	High correlation
`time_laden_stark_vorher` is highly correlated with `amperestunden` and 6 other fields	High correlation
`time_pause_vorher` is highly correlated with `zyklus_` and 5 other fields	High correlation
`time_temp_hoch` is highly correlated with `amperestunden` and 5 other fields	High correlation
`time_temp_hoch_vorher` is highly correlated with `amperestunden` and 8 other fields	High correlation
`time_amin` has unique values	Unique
`time_entladen_leicht_vorher` has unique values	Unique
`time_laden_stark_vorher` has unique values	Unique
`time_entladen_stark_vorher` has 40 (4.2%) zeros	Zeros
`time_pause_vorher` has 22 (2.3%) zeros	Zeros
`time_temp_hoch` has 593 (62.4%) zeros	Zeros
`time_temp_hoch_vorher` has 33 (3.5%) zeros	Zeros

Reproduction

Analysis started	2021-12-23 13:33:08.851870
Analysis finished	2021-12-23 13:33:32.809435
Duration	23.96 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

amperestunden
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	948
Distinct (%)	99.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.5014888

Minimum	0
Maximum	2.147192722
Zeros	3
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	7.5 KiB

Quantile statistics

Minimum	0
5-th percentile	1.011283349
Q1	1.253411514
median	1.491576156
Q3	1.754460949
95-th percentile	2.043836863
Maximum	2.147192722
Range	2.147192722
Interquartile range (IQR)	0.5010494347

Descriptive statistics

Standard deviation	0.3325745011
Coefficient of variation (CV)	0.2214964914
Kurtosis	0.2232667832
Mean	1.5014888
Median Absolute Deviation (MAD)	0.2526541546
Skewness	-0.2003476861
Sum	1426.41436
Variance	0.1106057988
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3	0.3%
1.781939909	1	0.1%
1.746756154	1	0.1%
2.008983757	1	0.1%
2.002933988	1	0.1%
1.943405937	1	0.1%
1.94311155	1	0.1%
1.863253171	1	0.1%
1.86467005	1	0.1%
1.801244912	1	0.1%
Other values (938)	938	98.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3	0.3%
0.6929784044	1	0.1%
0.7487782114	1	0.1%
0.750202993	1	0.1%
0.758739532	1	0.1%
0.7597755255	1	0.1%
0.7783643746	1	0.1%
0.7849392036	1	0.1%
0.8116476265	1	0.1%
0.8168337649	1	0.1%

Value	Count	Frequency (%)
2.147192722	1	0.1%
2.141582404	1	0.1%
2.138831784	1	0.1%
2.137437355	1	0.1%
2.136908838	1	0.1%
2.134823039	1	0.1%
2.134648283	1	0.1%
2.133916152	1	0.1%
2.132614816	1	0.1%
2.131995793	1	0.1%

zyklus_
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	861
Distinct (%)	90.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28218.97053

Minimum	1
Maximum	113576
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.5 KiB

Quantile statistics

Minimum	1
5-th percentile	865.8
Q1	7952.75
median	16073
Q3	39511.25
95-th percentile	93463.65
Maximum	113576
Range	113575
Interquartile range (IQR)	31558.5

Descriptive statistics

Standard deviation	28321.90788
Coefficient of variation (CV)	1.003647807
Kurtosis	0.8231802114
Mean	28218.97053
Median Absolute Deviation (MAD)	11970.5
Skewness	1.327962722
Sum	26808022
Variance	802130466
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	19	2.0%
3	8	0.8%
5	5	0.5%
1	4	0.4%
24209	4	0.4%
3031	4	0.4%
3033	4	0.4%
6057	4	0.4%
9087	4	0.4%
12111	4	0.4%
Other values (851)	890	93.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	4	0.4%
2	19	2.0%
3	8	0.8%
4	3	0.3%
5	5	0.5%
9	1	0.1%
40	1	0.1%
47	2	0.2%
854	1	0.1%
856	1	0.1%

Value	Count	Frequency (%)
113576	1	0.1%
113572	1	0.1%
110817	1	0.1%
110555	1	0.1%
110551	1	0.1%
109387	1	0.1%
109199	1	0.1%
109195	1	0.1%
107800	1	0.1%
107796	1	0.1%

temperature_amax
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	810
Distinct (%)	85.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-343.1336119

Minimum	-4099.44775
Maximum	44.93351
Zeros	0
Zeros (%)	0.0%
Negative	90
Negative (%)	9.5%
Memory size	7.5 KiB

Quantile statistics

Minimum	-4099.44775
5-th percentile	-4093.927
Q1	24.64716
median	27.059845
Q3	34.33386
95-th percentile	43.01202
Maximum	44.93351
Range	4144.38126
Interquartile range (IQR)	9.6867

Descriptive statistics

Standard deviation	1183.820648
Coefficient of variation (CV)	-3.450028231
Kurtosis	6.184014818
Mean	-343.1336119
Median Absolute Deviation (MAD)	3.35148
Skewness	-2.858384352
Sum	-325976.9313
Variance	1401431.326
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-4093.927	48	5.1%
-4094.09814	34	3.6%
24.43581	4	0.4%
24.33748	3	0.3%
24.46182	3	0.3%
23.67316	3	0.3%
24.2646	3	0.3%
27.25782	3	0.3%
23.31518	3	0.3%
43.09319	2	0.2%
Other values (800)	844	88.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-4099.44775	2	0.2%
-4094.09814	34	3.6%
-4093.927	48	5.1%
-4059.5376	2	0.2%
-70.1011	1	0.1%
-63.09559	1	0.1%
-57.93151	1	0.1%
-54.88553	1	0.1%
22.08074	1	0.1%
22.64744	1	0.1%

Value	Count	Frequency (%)
44.93351	1	0.1%
44.77131	1	0.1%
44.75011	1	0.1%
44.66674	1	0.1%
44.43338	1	0.1%
44.32677	1	0.1%
44.27815	1	0.1%
44.09966	1	0.1%
44.0831	1	0.1%
44.07764	1	0.1%

temperature_amin
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	807
Distinct (%)	84.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-369.2755797

Minimum	-4099.44775
Maximum	40.65417
Zeros	0
Zeros (%)	0.0%
Negative	91
Negative (%)	9.6%
Memory size	7.5 KiB

Quantile statistics

Minimum	-4099.44775
5-th percentile	-4093.927
Q1	19.4810675
median	21.80882
Q3	28.5679825
95-th percentile	38.9023835
Maximum	40.65417
Range	4140.10192
Interquartile range (IQR)	9.086915

Descriptive statistics

Standard deviation	1212.788638
Coefficient of variation (CV)	-3.284237314
Kurtosis	5.580768786
Mean	-369.2755797
Median Absolute Deviation (MAD)	3.336185
Skewness	-2.751126451
Sum	-350811.8007
Variance	1470856.28
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-4093.927	52	5.5%
-4094.09814	34	3.6%
-4099.44775	3	0.3%
28.66285	3	0.3%
21.06748	3	0.3%
19.5299	3	0.3%
20.98965	3	0.3%
19.71828	3	0.3%
19.16685	3	0.3%
19.02537	2	0.2%
Other values (797)	841	88.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-4099.44775	3	0.3%
-4094.09814	34	3.6%
-4093.927	52	5.5%
-4059.5376	2	0.2%
16.49812	1	0.1%
17.1661	1	0.1%
17.38354	1	0.1%
17.5044	1	0.1%
17.53201	1	0.1%
17.55559	1	0.1%

Value	Count	Frequency (%)
40.65417	1	0.1%
40.64124	1	0.1%
40.56391	1	0.1%
40.56279	1	0.1%
40.41031	1	0.1%
40.32174	1	0.1%
40.24242	1	0.1%
40.21308	1	0.1%
40.11925	1	0.1%
39.8741	1	0.1%

temperature_mean
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	870
Distinct (%)	91.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-362.7266643

Minimum	-4099.44775
Maximum	42.14114416
Zeros	0
Zeros (%)	0.0%
Negative	91
Negative (%)	9.6%
Memory size	7.5 KiB

Quantile statistics

Minimum	-4099.44775
5-th percentile	-4093.927
Q1	22.3161411
median	24.4982451
Q3	31.68772172
95-th percentile	41.02405727
Maximum	42.14114416
Range	4141.588894
Interquartile range (IQR)	9.371580623

Descriptive statistics

Standard deviation	1206.597105
Coefficient of variation (CV)	-3.326463765
Kurtosis	5.690477797
Mean	-362.7266643
Median Absolute Deviation (MAD)	3.192067399
Skewness	-2.770344446
Sum	-344590.331
Variance	1455876.574
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-4093.927	39	4.1%
-4094.09814	29	3.1%
-4093.927	9	0.9%
-4094.09814	5	0.5%
-4059.5376	2	0.2%
-4099.44775	2	0.2%
23.91183181	1	0.1%
41.20798725	1	0.1%
41.01648279	1	0.1%
41.50360734	1	0.1%
Other values (860)	860	90.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-4099.44775	2	0.2%
-4094.09814	5	0.5%
-4094.09814	29	3.1%
-4093.927	9	0.9%
-4093.927	39	4.1%
-4086.816011	1	0.1%
-4059.5376	2	0.2%
-4036.99036	1	0.1%
-4004.962801	1	0.1%
-3925.289877	1	0.1%

Value	Count	Frequency (%)
42.14114416	1	0.1%
42.11761987	1	0.1%
42.0327026	1	0.1%
41.91600623	1	0.1%
41.82337826	1	0.1%
41.81604031	1	0.1%
41.80844105	1	0.1%
41.75436561	1	0.1%
41.73001796	1	0.1%
41.69768148	1	0.1%

time_amin
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	950
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6860446.252

Minimum	1633.73
Maximum	17577173.69
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.5 KiB

Quantile statistics

Minimum	1633.73
5-th percentile	444543.7585
Q1	3126158.735
median	6566721.22
Q3	10263763.56
95-th percentile	14223182.87
Maximum	17577173.69
Range	17575539.96
Interquartile range (IQR)	7137604.822

Descriptive statistics

Standard deviation	4348495.994
Coefficient of variation (CV)	0.6338503115
Kurtosis	-0.8259038793
Mean	6860446.252
Median Absolute Deviation (MAD)	3508038.04
Skewness	0.2879996498
Sum	6517423939
Variance	1.890941741 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
385232.92	1	0.1%
3171585.87	1	0.1%
7858868.92	1	0.1%
208842.46	1	0.1%
226891.06	1	0.1%
814826.12	1	0.1%
832841.17	1	0.1%
1405694.42	1	0.1%
1424061.95	1	0.1%
2006333.65	1	0.1%
Other values (940)	940	98.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1633.73	1	0.1%
6294.22	1	0.1%
9754.78	1	0.1%
9800.31	1	0.1%
9800.84	1	0.1%
9813.11	1	0.1%
9849.62	1	0.1%
9966.34	1	0.1%
10018.01	1	0.1%
10092.75	1	0.1%

Value	Count	Frequency (%)
17577173.69	1	0.1%
17485573.05	1	0.1%
17470024.95	1	0.1%
17298505.87	1	0.1%
17085565.63	1	0.1%
17083278.63	1	0.1%
17054456.08	1	0.1%
16966176.51	1	0.1%
16941806.02	1	0.1%
16873033.81	1	0.1%

time_entladen_stark_vorher
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	597
Distinct (%)	62.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	205013.9202

Minimum	0
Maximum	593181.15
Zeros	40
Zeros (%)	4.2%
Negative	0
Negative (%)	0.0%
Memory size	7.5 KiB

Quantile statistics

Minimum	0
5-th percentile	22304.7675
Q1	123008.6775
median	203374.52
Q3	264311.3625
95-th percentile	480312.196
Maximum	593181.15
Range	593181.15
Interquartile range (IQR)	141302.685

Descriptive statistics

Standard deviation	123505.3834
Coefficient of variation (CV)	0.602424378
Kurtosis	0.8246641979
Mean	205013.9202
Median Absolute Deviation (MAD)	69319.5
Skewness	0.7630255465
Sum	194763224.2
Variance	1.525357972 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	40	4.2%
239704.04	4	0.4%
201767.84	2	0.2%
45712.61	2	0.2%
26248.56	2	0.2%
228812.91	2	0.2%
226026.61	2	0.2%
221762.48	2	0.2%
219154.11	2	0.2%
214002.42	2	0.2%
Other values (587)	890	93.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	40	4.2%
1441.61	1	0.1%
1597.06	1	0.1%
1616.74	1	0.1%
17749.62	2	0.2%
19338.98	1	0.1%
21926.61	2	0.2%
22766.96	2	0.2%
23109.02	1	0.1%
23298.04	1	0.1%

Value	Count	Frequency (%)
593181.15	1	0.1%
590747.87	1	0.1%
588001.68	1	0.1%
584509.3	1	0.1%
581060.04	1	0.1%
577898.06	1	0.1%
574226.15	1	0.1%
570478.33	1	0.1%
566288.94	1	0.1%
562124.13	1	0.1%

time_entladen_leicht_vorher
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	950
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1358084.162

Minimum	7538.12
Maximum	4347433.06
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.5 KiB

Quantile statistics

Minimum	7538.12
5-th percentile	123876.6955
Q1	468996.755
median	1105874.61
Q3	1896081.998
95-th percentile	3784764.458
Maximum	4347433.06
Range	4339894.94
Interquartile range (IQR)	1427085.243

Descriptive statistics

Standard deviation	1094643.005
Coefficient of variation (CV)	0.8060200065
Kurtosis	0.1013639948
Mean	1358084.162
Median Absolute Deviation (MAD)	679998.72
Skewness	0.9663618627
Sum	1290179954
Variance	1.198243308 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
196178.5	1	0.1%
714809.15	1	0.1%
337253.44	1	0.1%
198416.22	1	0.1%
205627.7	1	0.1%
318912.52	1	0.1%
325908.51	1	0.1%
420498.37	1	0.1%
427212.08	1	0.1%
517643.84	1	0.1%
Other values (940)	940	98.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
7538.12	1	0.1%
7539.59	1	0.1%
7542.95	1	0.1%
7552.6	1	0.1%
7610.03	1	0.1%
7616.33	1	0.1%
7629.05	1	0.1%
7634.98	1	0.1%
7661.04	1	0.1%
7665.27	1	0.1%

Value	Count	Frequency (%)
4347433.06	1	0.1%
4343519.61	1	0.1%
4268724.25	1	0.1%
4264733.78	1	0.1%
4234224.36	1	0.1%
4200003.53	1	0.1%
4184108.45	1	0.1%
4179980.68	1	0.1%
4159345.36	1	0.1%
4155906	1	0.1%

time_laden_stark_vorher
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	950
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3649026.058

Minimum	1627.08
Maximum	10850409.36
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.5 KiB

Quantile statistics

Minimum	1627.08
5-th percentile	180774.203
Q1	1667120.555
median	3387895.06
Q3	5026416.302
95-th percentile	8405080.343
Maximum	10850409.36
Range	10848782.28
Interquartile range (IQR)	3359295.747

Descriptive statistics

Standard deviation	2470853.712
Coefficient of variation (CV)	0.6771269025
Kurtosis	-0.3779777288
Mean	3649026.058
Median Absolute Deviation (MAD)	1671319.635
Skewness	0.5570831566
Sum	3466574755
Variance	6.105118064 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
194718.28	1	0.1%
2211298.91	1	0.1%
4734429.79	1	0.1%
11155.93	1	0.1%
21971.54	1	0.1%
444310.17	1	0.1%
455328.22	1	0.1%
881343.11	1	0.1%
893002.1	1	0.1%
1333416.55	1	0.1%
Other values (940)	940	98.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1627.08	1	0.1%
6289.18	1	0.1%
9394.74	1	0.1%
9440.27	1	0.1%
9440.8	1	0.1%
9453.07	1	0.1%
9489.58	1	0.1%
9606.3	1	0.1%
9657.97	1	0.1%
9732.74	1	0.1%

Value	Count	Frequency (%)
10850409.36	1	0.1%
10769780.97	1	0.1%
10468424.33	1	0.1%
10381041.46	1	0.1%
10306316.74	1	0.1%
10086358.66	1	0.1%
9995981.55	1	0.1%
9910653.22	1	0.1%
9763684.43	1	0.1%
9702559.45	1	0.1%

time_pause_vorher
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	798
Distinct (%)	84.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1050077.314

Minimum	0
Maximum	5585429.23
Zeros	22
Zeros (%)	2.3%
Negative	0
Negative (%)	0.0%
Memory size	7.5 KiB

Quantile statistics

Minimum	0
5-th percentile	16047.58
Q1	129139.4
median	648877.985
Q3	1504034.133
95-th percentile	3759876.513
Maximum	5585429.23
Range	5585429.23
Interquartile range (IQR)	1374894.733

Descriptive statistics

Standard deviation	1183726.529
Coefficient of variation (CV)	1.127275595
Kurtosis	2.110042012
Mean	1050077.314
Median Absolute Deviation (MAD)	555902.795
Skewness	1.575044181
Sum	997573448.2
Variance	1.401208495 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	22	2.3%
300	16	1.7%
14570.71	2	0.2%
16048.39	2	0.2%
16047.58	2	0.2%
28480.9	2	0.2%
43308.44	2	0.2%
54539.1	2	0.2%
68173.6	2	0.2%
79399.1	2	0.2%
Other values (788)	896	94.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	22	2.3%
300	16	1.7%
11400	1	0.1%
14570.71	2	0.2%
14574.91	2	0.2%
15817.74	2	0.2%
16046.88	2	0.2%
16047.58	2	0.2%
16048.39	2	0.2%
16065.26	2	0.2%

Value	Count	Frequency (%)
5585429.23	1	0.1%
5470150.93	1	0.1%
5378402.95	1	0.1%
5338495.03	1	0.1%
5302217.34	1	0.1%
5261931.65	1	0.1%
5170176.72	1	0.1%
5130269.14	1	0.1%
5093991.63	1	0.1%
5053697.84	1	0.1%

time_temp_hoch
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	358
Distinct (%)	37.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1977.097947

Minimum	0
Maximum	7730.64
Zeros	593
Zeros (%)	62.4%
Negative	0
Negative (%)	0.0%
Memory size	7.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4522.975
95-th percentile	6904.285
Maximum	7730.64
Range	7730.64
Interquartile range (IQR)	4522.975

Descriptive statistics

Standard deviation	2664.734842
Coefficient of variation (CV)	1.347801127
Kurtosis	-1.11352209
Mean	1977.097947
Median Absolute Deviation (MAD)	0
Skewness	0.764488618
Sum	1878243.05
Variance	7100811.776
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	593	62.4%
5552.06	1	0.1%
4684.59	1	0.1%
4439.53	1	0.1%
4436.76	1	0.1%
4376.34	1	0.1%
4364.01	1	0.1%
4495.3	1	0.1%
4513.65	1	0.1%
4784.88	1	0.1%
Other values (348)	348	36.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	593	62.4%
300	1	0.1%
2695.9	1	0.1%
2700.84	1	0.1%
2731.81	1	0.1%
2735.55	1	0.1%
2802.39	1	0.1%
2826.01	1	0.1%
2940.84	1	0.1%
2967.32	1	0.1%

Value	Count	Frequency (%)
7730.64	1	0.1%
7710.56	1	0.1%
7700.66	1	0.1%
7695.55	1	0.1%
7693.17	1	0.1%
7685.78	1	0.1%
7685.27	1	0.1%
7683.2	1	0.1%
7678.22	1	0.1%
7661.04	1	0.1%

time_temp_hoch_vorher
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	638
Distinct (%)	67.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2680278.352

Minimum	0
Maximum	11409748.64
Zeros	33
Zeros (%)	3.5%
Negative	0
Negative (%)	0.0%
Memory size	7.5 KiB

Quantile statistics

Minimum	0
5-th percentile	139765.7
Q1	793201.45
median	1767303.76
Q3	3737098.882
95-th percentile	8027307.819
Maximum	11409748.64
Range	11409748.64
Interquartile range (IQR)	2943897.432

Descriptive statistics

Standard deviation	2439237.488
Coefficient of variation (CV)	0.9100687197
Kurtosis	0.7340155128
Mean	2680278.352
Median Absolute Deviation (MAD)	1314359.26
Skewness	1.205400973
Sum	2546264435
Variance	5.949879525 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1578427.2	34	3.6%
0	33	3.5%
3739006.82	14	1.5%
1341971.38	12	1.3%
3393493.85	10	1.1%
1497579.63	10	1.1%
3038733.01	9	0.9%
1469602.17	9	0.9%
405011.46	8	0.8%
405611.66	8	0.8%
Other values (628)	803	84.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	33	3.5%
17395.4	1	0.1%
17591.57	1	0.1%
17757.17	1	0.1%
17797.63	1	0.1%
18462.93	1	0.1%
18506.4	1	0.1%
18585.12	1	0.1%
21609.26	1	0.1%
35609.14	1	0.1%

Value	Count	Frequency (%)
11409748.64	1	0.1%
10922820.59	1	0.1%
10890510.41	1	0.1%
10377187.11	1	0.1%
10346045.08	1	0.1%
10219232.41	1	0.1%
10186149.51	1	0.1%
9830754.11	1	0.1%
9798870.25	1	0.1%
9651188.08	1	0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	amperestunden	zyklus_	temperature_amax	temperature_amin	temperature_mean	time_amin	time_entladen_stark_vorher	time_entladen_leicht_vorher	time_laden_stark_vorher	time_pause_vorher	time_temp_hoch_vorher
0	2.000364	3	23.56742	18.39025	21.798768	385232.92	0.00	196178.50	194718.28	0.00	0.00
1	2.000250	5	24.06639	18.15403	21.449898	405533.19	0.00	203379.98	207816.73	0.00	0.00
2	1.958481	1009	22.81896	17.57133	20.530506	839519.21	17749.62	312669.57	472156.60	16048.39	178418.56
3	1.963192	1011	23.64538	18.12253	21.420698	858525.62	17749.62	319737.63	484111.86	16048.39	178418.56
4	1.911217	1925	23.89487	17.66582	20.839432	1248403.47	36155.14	406768.88	743215.33	28472.48	344313.14
5	1.915461	1927	23.34912	17.55559	20.933973	1267739.95	36155.14	413665.08	755670.79	28472.48	344313.14
6	1.869892	2829	23.64538	18.24852	21.355658	1655925.81	53512.10	507852.99	991901.35	43291.22	508390.77
7	1.866606	2831	22.64744	17.85481	20.966977	1675254.47	53512.10	514573.53	1004497.97	43291.22	508390.77
8	1.826606	3781	23.31793	18.40600	21.018691	2135722.57	71716.23	607684.52	1325711.87	55716.52	716060.80
9	1.832734	3783	23.61420	18.92570	21.702610	2154750.80	71716.23	614282.98	1338163.60	55716.52	716060.80

Last rows

	amperestunden	zyklus_	temperature_amax	temperature_amin	temperature_mean	time_amin	time_entladen_stark_vorher	time_entladen_leicht_vorher	time_laden_stark_vorher	time_pause_vorher	time_temp_hoch	time_temp_hoch_vorher
940	0.885836	101500	39.52802	35.21501	37.680454	11671142.74	311966.09	3883905.64	4709299.38	964202.21	3189.26	8.559283e+06
941	0.859189	101504	37.59567	32.32421	35.291661	11699932.70	311966.09	3886998.99	4727400.08	971702.21	3093.35	8.587977e+06
942	0.824189	104515	37.68842	32.20054	35.518379	11926129.42	314060.12	3952264.57	4823001.00	994867.83	2967.32	8.775022e+06
943	0.837322	104519	38.24494	32.69522	35.364958	11956170.18	314060.12	3955279.04	4842574.44	1002367.83	3014.47	8.805110e+06
944	0.778364	107536	37.70388	31.81407	35.174338	12177284.66	315859.21	4018987.09	4929998.11	1029183.27	2802.39	8.985943e+06
945	0.784939	107540	37.88939	31.96866	35.245658	12207354.10	315859.21	4021813.10	4949765.16	1036683.27	2826.01	9.016036e+06
946	0.759776	110551	37.79663	32.10779	35.343405	12427168.28	317601.49	4080113.57	5040620.52	1059934.58	2735.55	9.190943e+06
947	0.758740	110555	37.53384	31.59765	34.768506	12457189.16	317601.49	4082845.38	5060405.85	1067434.58	2731.81	9.220960e+06
948	0.748778	113572	38.29132	32.40151	35.719393	12672750.22	319549.85	4142731.52	5144349.95	1094276.63	2695.90	9.394390e+06
949	0.750203	113576	38.86329	32.46334	35.958514	12703478.83	319549.85	4145432.36	5164882.66	1101776.63	2700.84	9.425124e+06

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows